class CreateAsinInfos < ActiveRecord::Migration
  def self.up
    create_table :asin_infos do |t|
      t.string :asin
      t.string :isbn
      t.integer :author_id
      t.integer :publisher_id
      t.text :title
      t.text :detail_page_url
      t.text :medium_image_url
      t.text :large_image_url
      t.integer :sales_rank
      t.integer :total_reviews
      t.float :average_rating
      t.integer :price
      t.integer :number_ofpages
      t.date :publication_date
    end
  end

  def self.down
    drop_table :asin_infos
  end
end
